dbtのモデルでローカルからBigQueryにビューを作成してみる

Core:
  - installed: 1.8.3
  - latest:    1.8.3 - Up to date!

Plugins:
  - bigquery: 1.8.2 - Up to date!

test_project:
  outputs:
    dev:
      dataset: dbt_dataset
      job_execution_timeout_seconds: 300
      job_retries: 1
      location: US
      method: oauth
      priority: interactive
      project: [プロジェクトID]
      threads: 1
      type: bigquery
  target: dev

models
└── dbt_test

version: 1

sources:
  - name: samples_tables # データソースの名前
    database: bigquery-public-data # プロジェクト名
    schema: samples # データセット名
    tables: # テーブル名一覧
      - name: github_nested
      - name: shakespeare

FROM {{ source('samples_tables', 'github_nested') }}

models
└── dbt_test
    └── src_tables.yml

{{
    config(
        materialized='view'
    )
}}

WITH github_nested_cnt AS (
    SELECT
        'github_nested' AS table_name,
        COUNT(*) AS cnt
    FROM
        {{ source('samples_tables', 'github_nested') }}
),

shakespeare_cnt AS (
    SELECT
        'shakespeare' AS table_name,
        COUNT(*) AS cnt
    FROM
        {{ source('samples_tables', 'shakespeare') }}
)

SELECT
    table_name,
    cnt
FROM
    github_nested_cnt
UNION ALL
SELECT
    table_name,
    cnt
FROM
    shakespeare_cnt

models
└── dbt_test
    ├── mart.sql
    └── src_tables.yml

$ dbt run

Running with dbt=1.8.3
Registered adapter: bigquery=1.8.2
Unable to do partial parsing because a project config has changed
Found 1 model, 2 sources, 471 macros

Concurrency: 1 threads (target='dev')

1 of 1 START sql view model dbt_dataset.mart ................................... [RUN]
1 of 1 OK created sql view model dbt_dataset.mart .............................. [CREATE VIEW (0 processed) in 1.76s]

Finished running 1 view model in 0 hours 0 minutes and 5.75 seconds (5.75s).

Completed successfully

Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1